/ Business Heaven / Business Heaven.iso / accnting / bla / sampleya.db (.txt) | < prev | next > |
Paradox Database Table | 1992-08-08 | 6KB | 6 rows |
# | Employee,A,6 | Status,N,8 | Active,A,1 | Name,A,30 | Address,A,30 | Address2,A,30 | City,A,18 | State,A,3 | Zip Code,A,10 | Phone,A,12 | Comments,A,30 | SSAN,A,12 | Sex,A,1 | Marital Status,A,1 | Department,A,4 | Hire Date,N,8 | Pay Type,A,1 | Frequency,A,1 | Base Pay,N,8 | Overtime Rate1,N,8 | Overtime Rate2,N,8 | Holiday Rate,N,8 | Fed Deduction,N,8 | State Deduction,N,8 | City Deduction,N,8 | EIC Code,N,8 | Pay Social Security,A,1 | Pay FUTA,A,1 | Pay Ded User3,A,1 | Pay Ded User4,A,1 | Pay Ded User5,A,1 | Pay Ded User6,A,1 | State Exemption,N,8 | State Tax Credit,N,8 | Extra Fed Tax,N,8 | Extra State Tax,N,8 | Extra City Tax,N,8 | Extra Earnings,N,8 | Extra Deductions,N,8 | Amt Ded 401K,N,8 | Accured Vac Rate,N,8 | Accured Sick Rate,N,8 | SWH Pct Fed,N,8 | State Tax Table,A,2 | Wage Account,N,8 | YTD Salary Wages,N,8 | YTD Earn User1,N,8 | YTD Earn User2,N,8 | YTD Earn Extra,N,8 | YTD Earn EIC,N,8 | YTD Earn Tips,N,8 | YTD Soc Sec Wages,N,8 | YTD FUTA Wages,N,8 | YTD 401K Wages,N,8 | YTD CAFE Wages,N,8 | YTD User3 Wages,N,8 | YTD User4 Wages,N,8 | YTD User5 Wages,N,8 | YTD User6 Wages,N,8 | YTD Ded FWH,N,8 | YTD Ded SWH,N,8 | YTD Ded CWH,N,8 | YTD Ded Soc Sec,N,8 | YTD Ded Extra,N,8 | YTD Ded 401K,N,8 | YTD Ded User1,N,8 | YTD Ded User2,N,8 | YTD Ded User3,N,8 | YTD Ded User4,N,8 | YTD Ded User5,N,8 | YTD Ded User6,N,8 | YTD Ded Tips,N,8 | YTD Earn User1 nTax,N,8 | YTD Earn User2 nTax,N,8 | YTD Earn Extra nTax,N,8 | YTD Ded User1 nTax,N,8 | YTD Ded User2 nTax,N,8 | YTD Ded Extra nTax,N,8 | YTD Vacation,N,8 | YTD Sick,N,8 | YTD Hi Wages,N,8 | YTD Ded Hi,N,8 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 0.000000 | Y | First Employee | 123 Your Street | P.O. Box 1234 | Colorado Springs | CO | 80900 | 719-123-4567 | 111-22-3333 | F | S | 142445.000000 | H | B | 10.000000 | 15.000000 | 20.000000 | 20.000000 | 1.000000 | 1.000000 | 0.000000 | 0.000000 | Y | Y | Y | Y | N | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | CO | 5010.000000 | 160000.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 160000.000000 | 160000.000000 | 0.000000 | 0.000000 | 160000.000000 | 160000.000000 | 0.000000 | 0.000000 | 20076.000000 | 6750.000000 | 0.000000 | 9920.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 20.000000 | 10.000000 | 160000.000000 | 2320.000000 | ||
2 | 2 | 0.000000 | Y | John Q. Public | 123 Fourth Street | Anytown | CO | 80900 | 719-123-4567 | 111-22-3333 | M | M | 142476.000000 | H | B | 6.600000 | 9.900000 | 13.200000 | 13.200000 | 1.000000 | 1.000000 | 0.000000 | 0.000000 | Y | Y | Y | Y | N | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | CO | 5010.000000 | 105600.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 105600.000000 | 105600.000000 | 0.000000 | 0.000000 | 105600.000000 | 105600.000000 | 0.000000 | 0.000000 | 9264.000000 | 3184.000000 | 0.000000 | 6548.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 20.000000 | 10.000000 | 105600.000000 | 1532.000000 | |||
3 | 3 | 0.000000 | Y | Jane D. Citizen | 876 Any Street Lane | Beavertown | CO | 80900 | 719-555-1221 | 333-44-5555 | F | S | 142485.000000 | S | B | 650.000000 | 0.000000 | 0.000000 | 0.000000 | 1.000000 | 1.000000 | 0.000000 | 0.000000 | Y | Y | Y | Y | N | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | CO | 5010.000000 | 130000.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 130000.000000 | 130000.000000 | 0.000000 | 0.000000 | 130000.000000 | 130000.000000 | 0.000000 | 0.000000 | 15576.000000 | 5250.000000 | 0.000000 | 8060.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 10.000000 | 5.000000 | 130000.000000 | 1886.000000 | |||
4 | 4 | 0.000000 | Y | William D. Whomever | 1600 Pennsylvania Street | Anytown | CO | 80900 | 719=987-6543 | 777-00-0000 | M | M | 142523.000000 | H | B | 6.600000 | 9.900000 | 13.200000 | 13.200000 | 1.000000 | 1.000000 | 0.000000 | 0.000000 | Y | Y | Y | Y | N | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | CO | 5010.000000 | 105600.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 105600.000000 | 105600.000000 | 0.000000 | 0.000000 | 105600.000000 | 105600.000000 | 0.000000 | 0.000000 | 9264.000000 | 3184.000000 | 0.000000 | 6548.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 20.000000 | 10.000000 | 105600.000000 | 1532.000000 | |||
5 | 5 | 0.000000 | Y | Alice B. Whatshername | 876 Grand View Terrace | Colorado Springs | CO | 80900 | 719-528-0000 | 012-01-0123 | F | S | 142535.000000 | H | W | 7.000000 | 10.500000 | 14.000000 | 14.000000 | 1.000000 | 1.000000 | 0.000000 | 0.000000 | Y | Y | Y | Y | N | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | CO | 5010.000000 | 28000.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 28000.000000 | 28000.000000 | 0.000000 | 0.000000 | 28000.000000 | 28000.000000 | 0.000000 | 0.000000 | 3219.000000 | 1088.000000 | 0.000000 | 1736.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 60.000000 | 20.000000 | 28000.000000 | 406.000000 |